Test Step 2























































The Package Failed due to the error – Data conversion of the Location 1 returned status value 4 and status text “ Text was truncated or one …..” resolved this by changing the output column length to 4000 for the Locati
Troubles that occurred during the project:
- The Package Failed due to the error – Data conversion of the Location 1 returned status value 4 and status text “ Text was truncated or one …..” resolved this by changing the output column length to 4000 for the Location 1 column in the Source.
- Data cleanup for the Victim Business Name –the column has many special characters and address or date instead of name of the business, for example column has “7-Jul” instead of 7 Eleven … resolved this issue with update SQL Query.

https://outlook.live.com/mail/inbox/id/AQQkADAwATY0MDABLTgwMAAyLWQzNDUtMDACLTAwCgAQABnNNuQ%2Bn7VLs11RPTLAX5k%3D